CREATE TABLE [dbo].[VALCOMMTEMP]
(
[PortfolioID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PortfolioName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InstrClass] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InstrName] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[test] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OrigPurchDate] [datetime] NULL,
[Security_Identifier] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Is_Qualified] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset_Quality_Rating] [int] NULL,
[Depth] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Estimated_Duration] [decimal] (38, 12) NULL,
[Moody_Rating] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Spread] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GAAP_Yield_At_Purchase_Price] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GAAP_Yield_At_Current_Price] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Walk_In_GAAP_Yield] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Sum_Of_Adj_Par] [decimal] (38, 12) NULL,
[Amortized_Cost_Pct_of_Par] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Weighted_Avg_Price] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PriorNAVDate_Price] [decimal] (38, 12) NULL,
[NAVDate_Price] [decimal] (38, 12) NULL,
[Sum_Of_Amort_Cost] [decimal] (38, 12) NULL,
[Sum_Of_Mkt_Val] [decimal] (38, 12) NULL,
[Percent_of_MarketValue] [decimal] (38, 12) NULL,
[Net_Unrealized_Appreciation] [decimal] (38, 12) NULL,
[Pct_Net_Unreal_Gain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Sum_Of_Daily_Value_Change] [decimal] (38, 12) NULL,
[Price_Chg_Pct] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Sum_Of_Unreal_Dep] [decimal] (38, 12) NULL,
[Sum_Of_Unreal_App] [decimal] (38, 12) NULL,
[Proprietary_Reason] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Pricing_Method_Type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Interest_purchase_price_method] [decimal] (38, 12) NULL,
[Interest_current_price_method] [decimal] (38, 12) NULL,
[Sum_Of_Original_Cost] [decimal] (38, 12) NULL,
[Security_Type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FocusGroup] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FocusReason] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[portSortOrder] [int] NULL,
[instSortOrder] [int] NULL,
[Issuer_Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[prevQuarterPrice] [decimal] (38, 12) NULL,
[Bid] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Ask] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MaterialProvided] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[moodyChange] [int] NULL,
[priorMoodyRating] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[iss_Subsector] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[prop_Reason] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Prop_Track] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Maturity_Date] [datetime] NULL,
[Settle_Disc_prch] [decimal] (38, 12) NULL,
[Pik_Prch] [decimal] (38, 12) NULL,
[Coupon_Purch] [decimal] (38, 12) NULL
) ON [PRIMARY]
GO
